
/* Drop Tables */

DROP TABLE blog_color CASCADE CONSTRAINTS;
DROP TABLE blog_font CASCADE CONSTRAINTS;
DROP TABLE blog_skin CASCADE CONSTRAINTS;
DROP TABLE cart CASCADE CONSTRAINTS;
DROP TABLE product_comment CASCADE CONSTRAINTS;
DROP TABLE order_detail CASCADE CONSTRAINTS;
DROP TABLE product CASCADE CONSTRAINTS;
DROP TABLE shop_notice CASCADE CONSTRAINTS;
DROP TABLE spam CASCADE CONSTRAINTS;
DROP TABLE qa_comment CASCADE CONSTRAINTS;
DROP TABLE shop_qa CASCADE CONSTRAINTS;
DROP TABLE shop_blog CASCADE CONSTRAINTS;
DROP TABLE shop CASCADE CONSTRAINTS;
DROP TABLE category CASCADE CONSTRAINTS;
DROP TABLE delivery CASCADE CONSTRAINTS;
DROP TABLE product_order CASCADE CONSTRAINTS;
DROP TABLE customer CASCADE CONSTRAINTS;
DROP TABLE seller CASCADE CONSTRAINTS;
DROP TABLE zipcode CASCADE CONSTRAINTS;



/* Drop Sequences */

DROP SEQUENCE SEQ_product_comment_cmt_seq;
DROP SEQUENCE SEQ_product_order_order_seq;
DROP SEQUENCE SEQ_product_product_seq;
DROP SEQUENCE SEQ_qa_comment_cmt_seq;
DROP SEQUENCE SEQ_shop_qa_qa_seq;
DROP SEQUENCE SEQ_shop_shop_seq;
DROP SEQUENCE SEQ_spam_spam_seq;




/* Create Sequences */

CREATE SEQUENCE SEQ_product_comment_cmt_seq INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_product_order_order_seq INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_product_product_seq INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_qa_comment_cmt_seq INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_shop_qa_qa_seq INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_shop_shop_seq INCREMENT BY 1 START WITH 1;
CREATE SEQUENCE SEQ_spam_spam_seq INCREMENT BY 1 START WITH 1;



/* Create Tables */

CREATE TABLE blog_color
(
	color varchar2(50) NOT NULL,
	PRIMARY KEY (color)
);


CREATE TABLE blog_font
(
	-- 폰트
	font varchar2(50) NOT NULL,
	PRIMARY KEY (font)
);


CREATE TABLE blog_skin
(
	blog_skin varchar2(50) NOT NULL,
	PRIMARY KEY (blog_skin)
);


CREATE TABLE cart
(
	-- 회원아이디
	customer_id varchar2(20) NOT NULL,
	-- 상품고유코드 시퀀스
	product_seq number NOT NULL,
	-- 제품수량
	quantity number NOT NULL
);


CREATE TABLE category
(
	-- 상품 카테고리 키
	-- 
	category_key char(1) NOT NULL,
	-- 카테고리 이름
	category_value varchar2(30) NOT NULL,
	PRIMARY KEY (category_key)
);


CREATE TABLE customer
(
	-- 회원아이디
	customer_id varchar2(20) NOT NULL,
	-- 비밀번호
	password varchar2(20) NOT NULL,
	-- 회원명
	name varchar2(20) NOT NULL,
	-- 우편번호
	zipcode varchar2(10) NOT NULL,
	-- 기본 주소 동까지
	address1 varchar2(300) NOT NULL,
	-- 상세주소
	address2 varchar2(70) NOT NULL,
	-- 핸드폰 번호
	phone varchar2(15) NOT NULL,
	-- 이메일
	email varchar2(50) NOT NULL,
	-- 가입일
	inputdate date DEFAULT sysdate NOT NULL,
	PRIMARY KEY (customer_id)
);


CREATE TABLE delivery
(
	-- 주문번호 시퀀스
	order_seq number NOT NULL,
	-- 수령인 이름
	name varchar2(20) NOT NULL,
	-- 수령인 전화번호
	phone varchar2(15) NOT NULL,
	-- 수령인 우편번호
	zipcode varchar2(10) NOT NULL,
	-- 수령인 주소1
	address1 varchar2(300) NOT NULL,
	-- 수령인 상세주소
	address2 varchar2(70) NOT NULL,
	-- 배송관련 할 말
	delivery_comment varchar2(300),
	-- 장돌뱅이에게 할말
	jdb2_comment varchar2(300)
);


CREATE TABLE order_detail
(
	-- 상품고유코드 시퀀스
	product_seq number NOT NULL,
	-- 주문번호 시퀀스
	order_seq number NOT NULL,
	-- 주문의 quantity
	quantity number NOT NULL,
	-- 준비상태
	prep_status char(1) DEFAULT 'f' NOT NULL
);


CREATE TABLE product
(
	-- 상품고유코드 시퀀스
	product_seq number NOT NULL,
	-- 상점 고유시퀀스
	shop_seq number NOT NULL,
	-- 상품 카테고리 키
	-- 
	product_category char(1) NOT NULL,
	-- 상품명
	product_name varchar2(100) NOT NULL,
	-- 상품가격
	product_price number NOT NULL,
	-- 상품이미지1
	product_image1 clob NOT NULL,
	-- 상품이미지2
	product_image2 clob,
	-- 상품정보1
	product_info1 varchar2(1000) NOT NULL,
	-- 상품정보2
	product_info2 varchar2(1000),
	-- 상품입력날짜
	inputdate date NOT NULL,
	PRIMARY KEY (product_seq)
);


CREATE TABLE product_comment
(
	-- 상품코멘트의 시퀀스
	cmt_seq number NOT NULL,
	-- 회원아이디
	customer_id varchar2(20) NOT NULL,
	-- 상품고유코드 시퀀스
	product_seq number NOT NULL,
	content varchar2(200) NOT NULL,
	-- 코멘트입력시간
	inputdate date NOT NULL,
	PRIMARY KEY (cmt_seq)
);


CREATE TABLE product_order
(
	-- 주문번호 시퀀스
	order_seq number NOT NULL,
	-- 회원아이디
	customer_id varchar2(20) NOT NULL,
	-- 주문처리여부
	result char(1) NOT NULL,
	-- 주문 타입 (직접수령,익일배송)
	order_type char(1) NOT NULL,
	-- 주문일
	inputdate date NOT NULL,
	PRIMARY KEY (order_seq)
);


CREATE TABLE qa_comment
(
	-- 코멘트 시퀀스
	cmt_seq number NOT NULL,
	-- Q&A 시퀀스
	qa_seq number NOT NULL,
	-- 코멘트 제목
	cmt_title varchar2(100),
	-- 코멘트 내용
	cmt_contents varchar2(1000),
	-- 코멘트 글쓴이
	cmt_writer varchar2(50),
	-- 코멘트 날짜
	inputdate date,
	PRIMARY KEY (cmt_seq)
);


CREATE TABLE seller
(
	-- 상인아이디
	-- 관리자id: admin
	seller_id varchar2(20) NOT NULL,
	-- 비밀번호
	password varchar2(20) NOT NULL,
	-- 상인명
	name varchar2(20) NOT NULL,
	-- 우편번호
	zipcode varchar2(10) NOT NULL,
	-- 주소 동읍면까지
	address1 varchar2(300) NOT NULL,
	-- 상세주소
	address2 varchar2(70) NOT NULL,
	-- 상인 핸드폰
	phone varchar2(15) NOT NULL,
	-- 상인 email
	email varchar2(50),
	-- 가입날짜
	inputdate date NOT NULL,
	PRIMARY KEY (seller_id)
);


CREATE TABLE shop
(
	-- 상점 고유시퀀스
	shop_seq number NOT NULL,
	-- 상인아이디
	-- 관리자id: admin
	seller_id varchar2(20) NOT NULL,
	-- 상품 카테고리 키
	-- 
	category char(1) NOT NULL,
	-- 상점명
	name varchar2(50) NOT NULL,
	-- 우편번호
	zipcode varchar2(10) NOT NULL,
	address1 varchar2(300) NOT NULL,
	-- 상세주소
	address2 varchar2(70) NOT NULL,
	-- 상점전화번호
	phone varchar2(15) NOT NULL,
	PRIMARY KEY (shop_seq)
);


CREATE TABLE shop_blog
(
	-- 상점 고유시퀀스
	shop_seq number NOT NULL,
	-- 블로그 사진
	blog_photo clob,
	-- 블로그 폰트
	blog_font varchar2(20) DEFAULT 'anew',
	-- 블로그 배경화면
	blog_bgcolor varchar2(20) DEFAULT 'white',
	-- 블로그 게시판 스타일
	blog_style varchar2(50) DEFAULT 'Default',
	-- 블로그 옵션 슬라이드
	blog_slider number DEFAULT 0,
	-- 상점 지도
	blog_map number DEFAULT 1
);


CREATE TABLE shop_notice
(
	-- 상점 고유시퀀스
	shop_seq number NOT NULL,
	-- 공지사항 제목
	notice_title varchar2(100)
);


CREATE TABLE shop_qa
(
	-- Q&A 시퀀스
	qa_seq number NOT NULL,
	-- 회원아이디
	customer_id varchar2(20) NOT NULL,
	-- 상점 고유시퀀스
	shop_seq number NOT NULL,
	-- Q&A 제목
	-- 
	qa_title varchar2(100),
	-- Q&A 내용
	qa_contents varchar2(1000),
	-- Q&A 날짜
	inputdate date,
	PRIMARY KEY (qa_seq)
);


CREATE TABLE spam
(
	-- 스팸 시퀀스
	spam_seq number NOT NULL,
	-- 상점 고유시퀀스
	shop_seq number NOT NULL,
	-- 금칙어
	keywords varchar2(30) NOT NULL,
	PRIMARY KEY (spam_seq)
);


CREATE TABLE zipcode
(
	-- 우편번호
	zipcode varchar2(10) NOT NULL,
	-- 도,특별시
	area1 varchar2(25),
	-- 군구
	area2 varchar2(45),
	-- 동
	area3 varchar2(150),
	area4 varchar2(70)
);



/* Create Foreign Keys */

ALTER TABLE product
	ADD FOREIGN KEY (product_category)
	REFERENCES category (category_key)
;


ALTER TABLE shop
	ADD FOREIGN KEY (category)
	REFERENCES category (category_key)
;


ALTER TABLE product_order
	ADD FOREIGN KEY (customer_id)
	REFERENCES customer (customer_id)
;


ALTER TABLE product_comment
	ADD FOREIGN KEY (customer_id)
	REFERENCES customer (customer_id)
;


ALTER TABLE shop_qa
	ADD FOREIGN KEY (customer_id)
	REFERENCES customer (customer_id)
;


ALTER TABLE cart
	ADD FOREIGN KEY (customer_id)
	REFERENCES customer (customer_id)
;


ALTER TABLE cart
	ADD FOREIGN KEY (product_seq)
	REFERENCES product (product_seq)
;


ALTER TABLE product_comment
	ADD FOREIGN KEY (product_seq)
	REFERENCES product (product_seq)
;


ALTER TABLE order_detail
	ADD FOREIGN KEY (product_seq)
	REFERENCES product (product_seq)
;


ALTER TABLE order_detail
	ADD FOREIGN KEY (order_seq)
	REFERENCES product_order (order_seq)
;


ALTER TABLE delivery
	ADD FOREIGN KEY (order_seq)
	REFERENCES product_order (order_seq)
;


ALTER TABLE shop
	ADD FOREIGN KEY (seller_id)
	REFERENCES seller (seller_id)
;


ALTER TABLE shop_notice
	ADD FOREIGN KEY (shop_seq)
	REFERENCES shop (shop_seq)
;


ALTER TABLE spam
	ADD FOREIGN KEY (shop_seq)
	REFERENCES shop (shop_seq)
;


ALTER TABLE product
	ADD FOREIGN KEY (shop_seq)
	REFERENCES shop (shop_seq)
;


ALTER TABLE shop_qa
	ADD FOREIGN KEY (shop_seq)
	REFERENCES shop (shop_seq)
;


ALTER TABLE shop_blog
	ADD FOREIGN KEY (shop_seq)
	REFERENCES shop (shop_seq)
;


ALTER TABLE qa_comment
	ADD FOREIGN KEY (qa_seq)
	REFERENCES shop_qa (qa_seq)
;



/* Comments */

COMMENT ON COLUMN blog_font.font IS '폰트';
COMMENT ON COLUMN cart.customer_id IS '회원아이디';
COMMENT ON COLUMN cart.product_seq IS '상품고유코드 시퀀스';
COMMENT ON COLUMN cart.quantity IS '제품수량';
COMMENT ON COLUMN category.category_key IS '상품 카테고리 키
';
COMMENT ON COLUMN category.category_value IS '카테고리 이름';
COMMENT ON COLUMN customer.customer_id IS '회원아이디';
COMMENT ON COLUMN customer.password IS '비밀번호';
COMMENT ON COLUMN customer.name IS '회원명';
COMMENT ON COLUMN customer.zipcode IS '우편번호';
COMMENT ON COLUMN customer.address1 IS '기본 주소 동까지';
COMMENT ON COLUMN customer.address2 IS '상세주소';
COMMENT ON COLUMN customer.phone IS '핸드폰 번호';
COMMENT ON COLUMN customer.email IS '이메일';
COMMENT ON COLUMN customer.inputdate IS '가입일';
COMMENT ON COLUMN delivery.order_seq IS '주문번호 시퀀스';
COMMENT ON COLUMN delivery.name IS '수령인 이름';
COMMENT ON COLUMN delivery.phone IS '수령인 전화번호';
COMMENT ON COLUMN delivery.zipcode IS '수령인 우편번호';
COMMENT ON COLUMN delivery.address1 IS '수령인 주소1';
COMMENT ON COLUMN delivery.address2 IS '수령인 상세주소';
COMMENT ON COLUMN delivery.delivery_comment IS '배송관련 할 말';
COMMENT ON COLUMN delivery.jdb2_comment IS '장돌뱅이에게 할말';
COMMENT ON COLUMN order_detail.product_seq IS '상품고유코드 시퀀스';
COMMENT ON COLUMN order_detail.order_seq IS '주문번호 시퀀스';
COMMENT ON COLUMN order_detail.quantity IS '주문의 quantity';
COMMENT ON COLUMN order_detail.prep_status IS '준비상태';
COMMENT ON COLUMN product.product_seq IS '상품고유코드 시퀀스';
COMMENT ON COLUMN product.shop_seq IS '상점 고유시퀀스';
COMMENT ON COLUMN product.product_category IS '상품 카테고리 키
';
COMMENT ON COLUMN product.product_name IS '상품명';
COMMENT ON COLUMN product.product_price IS '상품가격';
COMMENT ON COLUMN product.product_image1 IS '상품이미지1';
COMMENT ON COLUMN product.product_image2 IS '상품이미지2';
COMMENT ON COLUMN product.product_info1 IS '상품정보1';
COMMENT ON COLUMN product.product_info2 IS '상품정보2';
COMMENT ON COLUMN product.inputdate IS '상품입력날짜';
COMMENT ON COLUMN product_comment.cmt_seq IS '상품코멘트의 시퀀스';
COMMENT ON COLUMN product_comment.customer_id IS '회원아이디';
COMMENT ON COLUMN product_comment.product_seq IS '상품고유코드 시퀀스';
COMMENT ON COLUMN product_comment.inputdate IS '코멘트입력시간';
COMMENT ON COLUMN product_order.order_seq IS '주문번호 시퀀스';
COMMENT ON COLUMN product_order.customer_id IS '회원아이디';
COMMENT ON COLUMN product_order.result IS '주문처리여부';
COMMENT ON COLUMN product_order.order_type IS '주문 타입 (직접수령,익일배송)';
COMMENT ON COLUMN product_order.inputdate IS '주문일';
COMMENT ON COLUMN qa_comment.cmt_seq IS '코멘트 시퀀스';
COMMENT ON COLUMN qa_comment.qa_seq IS 'Q&A 시퀀스';
COMMENT ON COLUMN qa_comment.cmt_title IS '코멘트 제목';
COMMENT ON COLUMN qa_comment.cmt_contents IS '코멘트 내용';
COMMENT ON COLUMN qa_comment.cmt_writer IS '코멘트 글쓴이';
COMMENT ON COLUMN qa_comment.inputdate IS '코멘트 날짜';
COMMENT ON COLUMN seller.seller_id IS '상인아이디
관리자id: admin';
COMMENT ON COLUMN seller.password IS '비밀번호';
COMMENT ON COLUMN seller.name IS '상인명';
COMMENT ON COLUMN seller.zipcode IS '우편번호';
COMMENT ON COLUMN seller.address1 IS '주소 동읍면까지';
COMMENT ON COLUMN seller.address2 IS '상세주소';
COMMENT ON COLUMN seller.phone IS '상인 핸드폰';
COMMENT ON COLUMN seller.email IS '상인 email';
COMMENT ON COLUMN seller.inputdate IS '가입날짜';
COMMENT ON COLUMN shop.shop_seq IS '상점 고유시퀀스';
COMMENT ON COLUMN shop.seller_id IS '상인아이디
관리자id: admin';
COMMENT ON COLUMN shop.category IS '상품 카테고리 키
';
COMMENT ON COLUMN shop.name IS '상점명';
COMMENT ON COLUMN shop.zipcode IS '우편번호';
COMMENT ON COLUMN shop.address2 IS '상세주소';
COMMENT ON COLUMN shop.phone IS '상점전화번호';
COMMENT ON COLUMN shop_blog.shop_seq IS '상점 고유시퀀스';
COMMENT ON COLUMN shop_blog.blog_photo IS '블로그 사진';
COMMENT ON COLUMN shop_blog.blog_font IS '블로그 폰트';
COMMENT ON COLUMN shop_blog.blog_bgcolor IS '블로그 배경화면';
COMMENT ON COLUMN shop_blog.blog_style IS '블로그 게시판 스타일';
COMMENT ON COLUMN shop_blog.blog_slider IS '블로그 옵션 슬라이드';
COMMENT ON COLUMN shop_blog.blog_map IS '상점 지도';
COMMENT ON COLUMN shop_notice.shop_seq IS '상점 고유시퀀스';
COMMENT ON COLUMN shop_notice.notice_title IS '공지사항 제목';
COMMENT ON COLUMN shop_qa.qa_seq IS 'Q&A 시퀀스';
COMMENT ON COLUMN shop_qa.customer_id IS '회원아이디';
COMMENT ON COLUMN shop_qa.shop_seq IS '상점 고유시퀀스';
COMMENT ON COLUMN shop_qa.qa_title IS 'Q&A 제목
';
COMMENT ON COLUMN shop_qa.qa_contents IS 'Q&A 내용';
COMMENT ON COLUMN shop_qa.inputdate IS 'Q&A 날짜';
COMMENT ON COLUMN spam.spam_seq IS '스팸 시퀀스';
COMMENT ON COLUMN spam.shop_seq IS '상점 고유시퀀스';
COMMENT ON COLUMN spam.keywords IS '금칙어';
COMMENT ON COLUMN zipcode.zipcode IS '우편번호';
COMMENT ON COLUMN zipcode.area1 IS '도,특별시';
COMMENT ON COLUMN zipcode.area2 IS '군구';
COMMENT ON COLUMN zipcode.area3 IS '동';

/*카테고리 정보*/
insert into category values('f','과일류');
insert into category values('v','채소류');
insert into category values('i','생선류');
insert into category values('m','육류');
insert into category values('g','식료품류');
insert into category values('h','건강용품');
insert into category values('a','패션');
insert into category values('l','생활용품');
insert into category values('e','기타');
/*font table*/
insert into blog_font values('바탕체');
insert into blog_font values('nanum');
insert into blog_font values('anew');
insert into blog_font values('궁서체');
/*color table*/
insert into blog_color values('white');
insert into blog_color values('yellow');
insert into blog_color values('teal');
insert into blog_color values('silver');
insert into blog_color values('red');
insert into blog_color values('purple');
insert into blog_color values('orange');
insert into blog_color values('olive');
insert into blog_color values('navy');
insert into blog_color values('maroon');
insert into blog_color values('lime');
insert into blog_color values('gray');
insert into blog_color values('green');
insert into blog_color values('fuchsia');
insert into blog_color values('blue');
insert into blog_color values('black');
insert into blog_color values('aqua');
/*skin table*/
insert into blog_skin values('Cerulean');
insert into blog_skin values('Cosmo');
insert into blog_skin values('Cyborg');
insert into blog_skin values('Darky');
insert into blog_skin values('Flatly');
insert into blog_skin values('Journal');
insert into blog_skin values('Lumen');
insert into blog_skin values('Paper');
insert into blog_skin values('Readable');
insert into blog_skin values('Sandstone');
insert into blog_skin values('Simplex');
insert into blog_skin values('Slate');
insert into blog_skin values('Spacelab');
insert into blog_skin values('Superhero');
insert into blog_skin values('United');
insert into blog_skin values('Yeti');

/*Seller data*/
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('admin','admin','관리자','111-111','서울시 강남구 삼성동','코엑스','010-1111-2222','admin@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('dlalstjs','1234','이민선','431-060','경기 안양시 동안구 관양동  ','234-12','010-7773-6817','dlalstjs@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('wlstmdals','1234','진승민','137-042','서울 서초구 반포2동  ','134-11','010-6606-0966','wlstmdals@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('ansduswl','1234','문연지','135-090','서울 강남구 삼성동  ','45-12','010-5125-7240','ansduswl@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('fbrltjd','1234','류기성','681-220','울산 중구 복산동  ','625-2','010-9129-9086','fbrltjd@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('rhqjawls','1234','고범진','472-864','경기 남양주시 진접읍 부평리  ','123-4','010-4170-5659','rhqjawls@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('wjsqudwn','wjsqudwn','전병주','136-110','서울 성북구 길음동  ','235-3','010-6408-1418','wjsqudwn@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('rlarltjr','1234','김기석','143-210','서울 광진구 광장동  ','653-12','010-5172-0520','rlarltjr@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('thsalstn','1234','손민수','136-110','서울 성북구 길음동  ','633-2','010-9913-7323','thsalstn@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('qkrtjdrhs','1234','박성곤','134-082','서울 강동구 고덕2동  ','154-5','010-3378-9252','qkrtjdrhs@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('dnjstkdgus','1234','원상현','156-050','서울 동작구 노량진동  ','262-6','010-6245-2362','dnjstkdgus@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('dlqndnjs','1234','이부원','431-717','경기 안양시 동안구 관양2동 인덕원삼성아파트  ','123-1102','010-3993-8644','dlqndnjs@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('tladnr','1234','심욱','110-041','서울 종로구 누상동  ','533-3','010-6262-1241','tladnr@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('rnjsdudwo','1234','권영재','403-014','인천 부평구 부평4동  ','456-234','010-3463-2112','rnjsdudwo@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('wkddydgus','1234','장용현','415-040','경기 김포시 사우동  ','236-2','010-5245-1311','wkddudgis@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('dlwnsdnd','1234','이준웅','135-280','서울 강남구 대치동  ','346-6','010-6690-6457','dlwnsdnd@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('answlsgur','1234','문진혁','140-021','서울 용산구 용산동1가  ','532-2','010-3623-2352','answlsgur@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('rlacjstlr','1234','김천식','138-170','서울 송파구 송파동  ','642-1','010-6575-3457','rlacjstlr@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('rjsdjanf','1234','건어물','134-072','서울 강동구 명일2동  ','341-1','010-1241-1231','rjsdjanf@gmail.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('wjdehdgns','1234','정동훈','135-090','서울 강남구 삼성동  ','235-6','010-6462-5235','wjdehdgns@naver.com',to_date('14/10/29','RR/MM/DD'));
Insert into SELLER (SELLER_ID,PASSWORD,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE,EMAIL,INPUTDATE) values ('gkswlsrb','1234','한진규','425-702','경기 안산시 고잔1동 안산시청  ','252-5','010-2426-3473','gkswlsrb@naver.com',to_date('14/10/29','RR/MM/DD'));

/*상점 데이터*/
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'dlalstjs','f','민선이네과일가게','138-220','서울 송파구 잠실동  ','213-29 ','02-422-0001');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'wlstmdals','v','승민이네채소가게','138-220','서울 송파구 잠실동  ','205-16','02-421-1456');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'ansduswl','g','파오파오','138-220','서울 송파구 잠실동  ','205-17','02-412-9198');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'fbrltjd','i','울산수산','138-220','서울 송파구 잠실동  ','208-7','02-563-1231');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'rhqjawls','f','우리청과','138-220','서울 송파구 잠실동  ','209-10','02-565-3841');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'wjsqudwn','v','야채나라','138-220','서울 송파구 잠실동  ','209-10','02-252-4363');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'rlarltjr','m','남서울축산','138-220','서울 송파구 잠실동  ','205-14','02-417-1859');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'thsalstn','i','송파수산','138-220','서울 송파구 잠실동  ','209-10','02-235-7475');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'qkrtjdrhs','h','장수건강원','138-220','서울 송파구 잠실동  ','205-12','02-532-1231');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'dnjstkdgus','m','축산물전문점','138-220','서울 송파구 잠실동  ','209-10','02-252-3377');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'dlqndnjs','a','보는패션에서듣는패션으로','138-220','서울 송파구 잠실동  ','205-14','02-246-3245');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'tladnr','g','명가떡집','138-220','서울 송파구 잠실동  ','209-10','02-633-2356');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'rnjsdudwo','l','나눔상회','138-229','서울 송파구 잠실본동  ','205-16','02-324-2322');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'wkddydgus','e','애완용품할인매장','138-220','서울 송파구 잠실동  ','205-4','02-623-1312');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'dlwnsdnd','h','태평선식','138-220','서울 송파구 잠실동  ','209-10','02-235-6436');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'answlsgur','a','한아름신발','138-220','서울 송파구 잠실동  ','209-10','02-574-3462');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'rlacjstlr','g','깻잎닭강정','138-220','서울 송파구 잠실동  ','213-55','02-433-1235');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'rjsdjanf','g','핑크건어물','138-229','서울 송파구 잠실본동  ','213-23','02-3453-1239');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'wjdehdgns','l','우리들의장터','138-220','서울 송파구 잠실동  ','209-10','02-643-6733');
Insert into SHOP (SHOP_SEQ,SELLER_ID,CATEGORY,NAME,ZIPCODE,ADDRESS1,ADDRESS2,PHONE) values (SEQ_SHOP_SHOP_SEQ.NEXTVAL,'gkswlsrb','e','대영꽃방','138-220','서울 송파구 잠실동  ','209-10','02-643-2356');

/*상점 블로그 데이터*/
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (10,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (11,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (12,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (13,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (14,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (15,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (16,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (17,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (18,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (19,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (1,'anew','maroon','Cyborg',1,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (2,'nanum','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (3,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (4,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (6,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (7,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (8,'anew','white','Default',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (9,'nanum','yellow','Yeti',0,1);
Insert into SHOP_BLOG (SHOP_SEQ,BLOG_FONT,BLOG_BGCOLOR,BLOG_STYLE,BLOG_SLIDER,BLOG_MAP) values (20,'anew','white','Default',0,1);

/*customer ID 생성*/
insert into customer values 
	(
		'customer'
		, '1234'
		, '이민선'
		, '135-975'
		, '서울특별시 강남구 삼성동 159 코엑스'
		, '무역센타4층'
		, '010-1234-5678'
		, 'customer@kita.net'
		, sysdate
	);

insert into customer values 
	(
		'winner'
		, '1234'
		, '송민호'
		, '138-861'
		, '서울특별시 송파구 백제고분로12길 20'
		, '101호 (잠실동, 잠실동빌라)'
		, '010-4568-4138'
		, 'winner@hanmail.net'
		, sysdate
	);
	
insert into customer values 
	(
		'apink'
		, '1234'
		, '정은지'
		, '138-865'
		, '서울특별시 송파구 잠실동 176-2 잠실동'
		, '렉스빌2차 203호'
		, '010-1359-6945'
		, 'apink@hanmail.net'
		, sysdate
	);
		
insert into customer values 
	(
		'mssee123'
		, '1234'
		, '최현미'
		, '138-864'
		, '서울특별시 송파구 삼전로 71 (잠실동)'
		, '한빛아파트5동 701호'
		, '010-7823-6103'
		, 'mssee123@hanmail.net'
		, sysdate
	);
		
insert into customer values 
	(
		'DryJins'
		, '1234'
		, '진승민'
		, '138-865'
		, '서울특별시 송파구 도곡로 452 (잠실동)'
		, '도곡아파트 304동 1803호'
		, '010-6479-8889'
		, 'DryJins@gmail.com'
		, sysdate
	);
		
insert into customer values 
	(
		'yuending90'
		, '1234'
		, '문연지'
		, '138-892'
		, '서울특별시 송파구 올림픽로 8 (잠실동)'
		, '올림픽 아파트 1동 702호'
		, '010-3165-4756'
		, 'yuending90@gmail.com'
		, sysdate
	);
		
insert into customer values 
	(
		'f2hard3'
		, '1234'
		, '박성곤'
		, '138-867'
		, '서울특별시 송파구 삼전로3길 3 (잠실동)'
		, '송파아파트 502동 305호'
		, '010-5106-0026'
		, 'f2hard3@gmail.com'
		, sysdate
	);
		
insert into customer values 
	(
		'stunelun'
		, '1234'
		, '정은지'
		, '138-864'
		, '서울특별시 송파구 잠실동 249-15'
		, '삼진빌라 A동'
		, '010-1359-6945'
		, 'stunelun@gmail.net'
		, sysdate
	);
		
insert into customer values 
	(
		'veronica410'
		, '1234'
		, '최윤희'
		, '138-889'
		, '서울특별시 송파구 백제고분로 2 (잠실동)'
		, '104호'
		, '010-7596-8961'
		, 'veronica410@naver.com'
		, sysdate
	);
			
insert into customer values 
	(
		'dominic7785'
		, '1234'
		, '손재민'
		, '138-864'
		, '서울특별시 송파구 삼전로13길 8'
		, '501호 (잠실동)'
		, '010-3519-6033'
		, 'dominic7785@naver.com'
		, sysdate
	);		
	
insert into customer values 
	(
		'love_love486'
		, '1234'
		, '남수진'
		, '138-864'
		, '서울특별시 송파구 삼전로7길 24'
		, '401호 (잠실동'
		, '010-3547-4619'
		, 'love_love486@naver.com'
		, sysdate
	);	
	
insert into customer values 
	(
		'showMe9564'
		, '1234'
		, '윤영일'
		, '138-861'
		, '서울특별시 송파구 백제고분로 2 (잠실동)'
		, '104호'
		, '010-7596-8961'
		, 'showMe9564@naver.com'
		, sysdate
	);		
	
insert into customer values 
	(
		'rocknroll1235'
		, '1234'
		, '곽경철'
		, '138-865'
		, '서울특별시 송파구 도곡로64길 11'
		, '302호 (잠실동)'
		, '010-5532-6478'
		, 'rocknroll1235@hanmail.net'
		, sysdate
	);
	
insert into customer values 
	(
		'o_oa5738'
		, '1234'
		, '곽경철'
		, '138-862'
		, '서울특별시 송파구 잠실동 196-7'
		, '샘마을 605동 1202호'
		, '010-6315-0264'
		, 'o_oa5738@hanmail.net'
		, sysdate
	);
	
insert into customer values 
	(
		'gon2thezo'
		, '1234'
		, '곽경철'
		, '138-865'
		, '서울특별시 송파구 삼전로13길 11 (잠실동)'
		, '영아아파트 502동 601호'
		, '010-6152-1102'
		, 'gon2thezo@hanmail.net'
		, sysdate
	);

insert into customer values 
	(
		'mino666'
		, '1234'
		, '최정진'
		, '138-864'
		, '서울특별시 송파구 삼전로13길 14 (잠실동)'
		, '성일아파트 401동 1604호'
		, '010-7403-4903'
		, 'mino666@hanmail.net'
		, sysdate
	);
	

insert into customer values 
	(
		'akaAndre'
		, '1234'
		, '안드레'
		, '138-864'
		, '서울특별시 송파구 삼전로9길 5-2 (잠실동)'
		, '일정빌라 502호'
		, '010-3056-4620'
		, 'akaAndre@hanmail.net'
		, sysdate
	);
	

insert into customer values 
	(
		'lgy3070'
		, '1234'
		, '류기성'
		, '138-862'
		, '서울특별시 송파구 석촌호수로 68 (잠실동)'
		, '석촌아파트 1단지 902호'
		, '010-1355-3302'
		, 'lgy3070@hanmail.net'
		, sysdate
	);
	

insert into customer values 
	(
		'10ksup'
		, '1234'
		, '이영섭'
		, '138-863'
		, '서울특별시 송파구 백제고분로 109 (잠실동)'
		, '성일아파트 405동 104호'
		, '010-5464-4564'
		, '@hanmail.net'
		, sysdate
	);

Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','머루포도',8900,'* 머루포도
* 원산지: 국내산
','칼슘, 인, 안토시아닌이 풍부하며
과육이 부드럽고 당도가 높아 달콤한 향이 진합니다.

머루와 교배한 품종으로 머루포도의 장점을 살린 포도입니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','청양 고추',990,'원산지: 국내산','맵습니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','단감(6-10입/봉)',8900,'국내산

아삭하고 달콤한 단감 6-10입/봉
단감과수(갯수)가 많을수록 단감 크기는 작아지며, 과수가 적으면 크기가 큽니다.','아삭아삭 식감 좋고 달콤한 ''단감''

키위를 사랑하고 단감을 좋아하며
체리를 아끼는 부부 농부의 맛있는 단감을 직접 떼옵니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','한라봉 황금향(1kg)',8980,'한라봉 1kg
국내산
','제주가 낳은 황금알

제주 영평 정보화 마을
-제주특별자치도 제주시 영평동

천의 제주에서 자란 황금향

황금향은?
부와 명품의 향기라는 뜻을 지는 천혜향과
한라봉을 접목시켜 만든 신품종

※왁스 코팅, 강제 착색 하지 않습니다.※
※아무거나 담아 보내드리지 않습니다.※

',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','금귤(1kg)',5200,'국내산','귀엽고 조그매서 귀여운 금귤! 낑깡
온 가족이 먹어봐요^^',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','깻잎',990,'원산지: 중국','신선한 깻잎님.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','배(2입/봉)',9500,'국내산','아삭아삭 꿀맛 나는 시원한 배
달콤한 과즙이 풍부한 맛있는 배로 갈증을 해소하세요~

색은 밝은 황갈색이면서 깨끗해 보이는 배가 좋습니다.
모양은 둥글수록 맛있고
싱그러운 향이 나면서 단단할 수록  맛있고 품질이 좋은 배입니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','대파',1880,'원산지: 국내','긴 대파 ',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','돼지 감자',3980,'원사지: 국내, 2kg/봉','다이어트 굿',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval0,1,'f','후레쉬체리(100g)',3300,'미국산
100g','과일의 여왕이라는 애칭을 가지고 있는 체리는
우리 순수한 말로 버찌라고 합니다.
북반구가 원산지이며 대부분의 종이 북아메리카에서 자라며 유럽에서도 자라기도 합니다.
체리는 아주 짧은 기간동안에만 맛볼 수 있으며
빨강 빛깔과 귀여운 모양에 여성분들이 많이 선호하는 과일입니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','통마늘',990,'원산지: 국내, 1.5kg/망','맛있음',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','아오리사과(2kg)',7990,'국내산
2kg','바쁜 아침 작아서 베어먹기 좋아요
새콤하고 아삭아삭 상큼한 아오리사과',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','부추',2280,'원산지:국내, 1단','부추는 부추추추추추',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','시금치',1100,'원산지:국내, 1단','시금치는 치치치치치치',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','망고(특대 1개)',5000,'태국산(직수입)
특대
','특대사이즈 망고 개당판매합니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','애호박',1100,'원산지:국내, 1개','애호박은 애호호호호홓',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','골드파인애플(1개)',3900,'필리핀산
직수입
1개','Dole_스위티오파인애플 1개!',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','양파',2980,'원산지: 국내, 3kg/망','양파파파파파파팦',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','하우스꿀딸기(2kg)',15000,'국내산
하우스꿀딸기
2.0kg','하우스 꿀딸기 첫출하
저렴한 가격에 드립니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','특가/씨없는감(10kg)',6900,'국내산(경북 청도산)
10kg
특가','전국최대의 감생산지 경북청도에서 재배된 최상품 홍시입니다.
청도반시는 식재 후 3년만에 수확이 가능하며 타지역 감보다
해거리가 적고 수확기도 빠릅니다.
육질이 연하고 당도가 높으며 씨가 전혀 없으나 청도 지역 외
타지역에서 재배를 하면 씨가 생기는 특징이 있습니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,1,'f','하우스수박',9900,'국내산
4kg 내외
고당도','비만의 90%는 운동부족과 필수영양소가 결핍된 음식을 먹은 결과!
식이섬유로 각종 영양성분을 보충하세요!!!
대사율이 올라갑니다!!',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,6,'v','햇배추',2000,'국내산
햇배추
1통','유기농 배추입니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','오이',450,'원산지: 국내, 1개','백다다기 오이!',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'f','피망',20500,'원산지:국내산, 5kg','익산원예농협/산지직송!',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,6,'v','연근',5000,'연근 1kg
국내산
봉촌연근농장','봉촌연근은 유기질이 많은 토양(점질양토)에서 재배되어,
맛과 색이 탁월하고 품질이 좋으며 구멍의 크기가 고릅니다.
',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,6,'v','상추500g',3500,'국내산 무농약 상추
500g','전남 장성에서 재배된 무농약 상추
고기 먹을 때 빠질 수 없는 상추~!
아삭아삭 씹히는 신선한 상추는 그야말로 싱그러움 자체입니다!!',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,6,'v','햇양파(1개)',200,'국내산
특대사이즈 햇양파1개','양파김치, 양파장아찌 등 다양한 양파요리를 즐겨보세요.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','한우 꽃등심(500g)',32900,'전라도 1등급 청정한우
꽃등심
500g','전라남도 1등급 청정한우 암소로 한우의 깊은 맛을 느낄 수 있습니다.

꽃등심은 일반 등심부위보다 마블링의 분포가 더 고르고
넓게 분포되어 더욱 더 뛰어난 맛과 식감을 자랑하는 고급부위입니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,5,'f','감귤',13800,'원산지: 국내산, 1.5kg/박스 
','황금향!',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,5,'f','감말랭이',4980,'원산지: 국내산, 200g/팩','감을 쫄깃하게 말려두었습니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,5,'f','대추',4980,'원산지: 국내산, 500g/팩','맛! 대! 추!',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','목심 불고기(500g)',7500,'호주산
목심(불고기용)
500g
','담백하고 부드러운 육질로 불고기감으로 슬라이스된 우목심입니다.
',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','닭날개',3200,'국내산
닭날개
400g
','깨끗한 환경에서 자라난 무항생제 1등급 건강한 제주 닭을
보다 신선하고 맛있게 즐기시도록 냉장배송 해드립니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','닭모래집',4000,'국내산
닭모래집
500g','안주에 안성맞춤인 닭모래주머니!
시원한 소주에 한 입 어때요?',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','한우 국거리(덩어리) 500g',8000,'호주 청정우
국거리(덩어리)
500g','목등심을 이용하여 기름기적고 담백한 국물맛을 제대로 즐길 수 있는 품목입니다.
한우 못지 않은 진한 국물맛을 느낄 수 있습니다.',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','닭발',6500,'1kg
뼈있는 통닭발
국내산
','소주와 함께 즐기세요^^*',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','[名品]횡성한우 도가니 700g',14500,'[名品]횡성한우 도가니 
700g
(1등급 이상)','횡성군수 품질인증!
HACCP 전용사업장!!',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','돼지 등심',4700,'돈등심
500g','장조림, 돈까스, 카레용으로 적합한 돼지 등심입니다.',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','돼지 안심',4600,'철원 돼지 등심
500g','장조림, 돈까스, 카레에 안성맞춤입니다!
강력추천!!!!',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','돼지 목살(100g)',2000,'국내산
돈목심
100g','현재 구매 단위 (100)g
600g구매시 구매수량을 6으로 지정하여 장바구니에 담으시면 됩니다^^

구이용으로 아주 적합한 목살!
모두 구워먹어보세요><',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','한우사골(1.3kg)',28000,'국내산
한우사골
1.3kg
','추운 겨울 한우 사골로 뜨뜻한 사골곰탕 만들어 보세요!',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,7,'m','삼겹살(구이/수육)',4600,'삼겹살(구이/수육)
500g
수입산','삼겹살은 언제 어디서나 누구든지 좋아하는 국민메뉴로
남녀노소 할 것 없이 누구나 즐겨찾는 상품입니다.
적절한 살코기와 지방의 조화로 쫄깃함과 부드러운 맛을 즐기실 수 있으며
국내산 못지 않은 신선함과 깔끔함으로 가정에서 편리하게 만나보세요!',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'f','토마토',9800,'원산지:국내산, 2kg/박스','토마토는 마마마마토토토토토',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT (PRODUCT_SEQ,SHOP_SEQ,PRODUCT_CATEGORY,PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_INFO1,PRODUCT_INFO2,INPUTDATE) values (seq_product_product_seq.nextval,2,'v','test',3000,'123132','123123123',to_date('14/10/30','RR/MM/DD'));

/*order 정보*/
Insert into PRODUCT_ORDER (ORDER_SEQ,CUSTOMER_ID,RESULT,ORDER_TYPE,INPUTDATE) values (SEQ_product_order_order_seq.nextval,'customer','t','s',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT_ORDER (ORDER_SEQ,CUSTOMER_ID,RESULT,ORDER_TYPE,INPUTDATE) values (SEQ_product_order_order_seq.nextval,'winner','f','s',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT_ORDER (ORDER_SEQ,CUSTOMER_ID,RESULT,ORDER_TYPE,INPUTDATE) values (SEQ_product_order_order_seq.nextval,'winner','f','s',to_date('14/10/29','RR/MM/DD'));
Insert into PRODUCT_ORDER (ORDER_SEQ,CUSTOMER_ID,RESULT,ORDER_TYPE,INPUTDATE) values (SEQ_product_order_order_seq.nextval,'10ksup','f','s',to_date('14/10/30','RR/MM/DD'));
Insert into PRODUCT_ORDER (ORDER_SEQ,CUSTOMER_ID,RESULT,ORDER_TYPE,INPUTDATE) values (SEQ_product_order_order_seq.nextval,'lgy3070','f','d',to_date('14/10/30','RR/MM/DD'));

/*order detail*/
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (43,1,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (40,1,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (35,1,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (1,2,10,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (3,2,5,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (4,2,4,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (5,2,3,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (7,2,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (10,2,1,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (21,3,5,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (20,3,4,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (19,3,3,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (17,3,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (15,3,1,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (3,4,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (20,4,2,'f');
Insert into ORDER_DETAIL (PRODUCT_SEQ,ORDER_SEQ,QUANTITY,PREP_STATUS) values (17,5,5,'f');

select * from shop_blog;